SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwbDivisionestemp
AS
SELECT     dbo.tb_Divisionestemp.idDivision AS ID, dbo.tb_Divisionestemp.Descripcion, dbo.tb_Divisionestemp.Mnemo, 
                      dbo.tb_Divisionestemp.Curso, dbo.tb_Divisionestemp.Division, dbo.tb_GrupoDeCarreras.descripcion AS Grupo_Carreras, 
                      dbo.tb_Turnos.Descripcion AS Turno, dbo.tb_Divisionestemp.CUISE
FROM         dbo.tb_Divisionestemp INNER JOIN
                      dbo.tb_GrupoDeCarreras ON dbo.tb_Divisionestemp.GrupoCarreras = dbo.tb_GrupoDeCarreras.idGrupoCarrera INNER JOIN
                      dbo.tb_Turnos ON dbo.tb_Divisionestemp.Turno = dbo.tb_Turnos.idTurno

GO
GRANT SELECT ON  [dbo].[vwbDivisionestemp] TO [Alumnos]
GRANT SELECT ON  [dbo].[vwbDivisionestemp] TO [SoloVer]
GO
